﻿CREATE PROCEDURE [dbo].[GetBooksForAuthor]
	@authorId int
AS
	select	bv.*
	from	BookAuthor as ba
	inner   join BookView as bv on bv.BookId = ba.BookId
	where	ba.AuthorId = @authorId
	order   by bv.Title;
RETURN 0